{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Number</th>\n",
       "      <th>main_score</th>\n",
       "      <th>123_score</th>\n",
       "      <th>sign_score</th>\n",
       "      <th>tatal_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20183180105</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.236265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20183180109</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.236265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20183180122</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.236265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>20183180129</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>84.878262</td>\n",
       "      <td>81.699744</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>20183180137</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>80.236265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>32017120070</td>\n",
       "      <td>82.953314</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>95.619231</td>\n",
       "      <td>85.867095</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>32017120095</td>\n",
       "      <td>81.771988</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>90.938846</td>\n",
       "      <td>83.990449</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>32017120096</td>\n",
       "      <td>80.590663</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>89.728756</td>\n",
       "      <td>83.154892</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>32017150053</td>\n",
       "      <td>88.269279</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>88.151613</td>\n",
       "      <td>85.753196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>32017150058</td>\n",
       "      <td>94.766569</td>\n",
       "      <td>80.808271</td>\n",
       "      <td>91.232846</td>\n",
       "      <td>89.518963</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>116 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          Number  main_score  123_score  sign_score  tatal_score\n",
       "0    20183180105   80.590663  80.000000   80.000000    80.236265\n",
       "1    20183180109   80.590663  80.000000   80.000000    80.236265\n",
       "2    20183180122   80.590663  80.000000   80.000000    80.236265\n",
       "3    20183180129   80.590663  80.000000   84.878262    81.699744\n",
       "4    20183180137   80.590663  80.000000   80.000000    80.236265\n",
       "..           ...         ...        ...         ...          ...\n",
       "111  32017120070   82.953314  80.000000   95.619231    85.867095\n",
       "112  32017120095   81.771988  80.000000   90.938846    83.990449\n",
       "113  32017120096   80.590663  80.000000   89.728756    83.154892\n",
       "114  32017150053   88.269279  80.000000   88.151613    85.753196\n",
       "115  32017150058   94.766569  80.808271   91.232846    89.518963\n",
       "\n",
       "[116 rows x 5 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "pd.set_option('display.max_rows',10)#显示行部分\n",
    "pd.set_option('display.max_columns',None)#显示列部分\n",
    "data=pd.read_csv('score01.csv',encoding='utf-8')#读取数据集\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "data['main_score']=data['main_score'].astype('int')\n",
    "data['123_score']=data['123_score'].astype('int')\n",
    "data['sign_score']=data['sign_score'].astype('int')\n",
    "data['tatal_score']=data['tatal_score'].astype('int')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>main_score</th>\n",
       "      <th>123_score</th>\n",
       "      <th>sign_score</th>\n",
       "      <th>tatal_score</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Number</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>20183180105</th>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20183180109</th>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20183180122</th>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20183180129</th>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "      <td>84</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20183180137</th>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017120070</th>\n",
       "      <td>82</td>\n",
       "      <td>80</td>\n",
       "      <td>95</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017120095</th>\n",
       "      <td>81</td>\n",
       "      <td>80</td>\n",
       "      <td>90</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017120096</th>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "      <td>89</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017150053</th>\n",
       "      <td>88</td>\n",
       "      <td>80</td>\n",
       "      <td>88</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017150058</th>\n",
       "      <td>94</td>\n",
       "      <td>80</td>\n",
       "      <td>91</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>116 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             main_score  123_score  sign_score  tatal_score\n",
       "Number                                                     \n",
       "20183180105          80         80          80           80\n",
       "20183180109          80         80          80           80\n",
       "20183180122          80         80          80           80\n",
       "20183180129          80         80          84           81\n",
       "20183180137          80         80          80           80\n",
       "...                 ...        ...         ...          ...\n",
       "32017120070          82         80          95           85\n",
       "32017120095          81         80          90           83\n",
       "32017120096          80         80          89           83\n",
       "32017150053          88         80          88           85\n",
       "32017150058          94         80          91           89\n",
       "\n",
       "[116 rows x 4 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.set_index([\"Number\"], inplace=True)#将学号设置为索引\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Number</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>22019207065</th>\n",
       "      <td>张泽远</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22019208018</th>\n",
       "      <td>王祎</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210084</th>\n",
       "      <td>李睿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210088</th>\n",
       "      <td>韩文杰</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22020210091</th>\n",
       "      <td>崔明悦</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017120070</th>\n",
       "      <td>杜明旭</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017120095</th>\n",
       "      <td>马紫来</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017120096</th>\n",
       "      <td>高子轩</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017150053</th>\n",
       "      <td>郝雨桐</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32017150058</th>\n",
       "      <td>龙菁</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>106 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Name\n",
       "Number          \n",
       "22019207065  张泽远\n",
       "22019208018   王祎\n",
       "22020210084   李睿\n",
       "22020210088  韩文杰\n",
       "22020210091  崔明悦\n",
       "...          ...\n",
       "32017120070  杜明旭\n",
       "32017120095  马紫来\n",
       "32017120096  高子轩\n",
       "32017150053  郝雨桐\n",
       "32017150058   龙菁\n",
       "\n",
       "[106 rows x 1 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "data2=pd.read_csv('num.csv',encoding='gbk')#读取学号数据集\n",
    "data2.set_index([\"Number\"], inplace=True)\n",
    "data2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Number</th>\n",
       "      <th>Name</th>\n",
       "      <th>main_score</th>\n",
       "      <th>123_score</th>\n",
       "      <th>sign_score</th>\n",
       "      <th>tatal_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20183180105</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20183180109</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20183180122</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>20183180129</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>81.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>20183180137</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>32017120070</td>\n",
       "      <td>杜明旭</td>\n",
       "      <td>82.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>85.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>32017120095</td>\n",
       "      <td>马紫来</td>\n",
       "      <td>81.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>83.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>32017120096</td>\n",
       "      <td>高子轩</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>83.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>32017150053</td>\n",
       "      <td>郝雨桐</td>\n",
       "      <td>88.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>85.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>32017150058</td>\n",
       "      <td>龙菁</td>\n",
       "      <td>94.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>119 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          Number Name  main_score  123_score  sign_score  tatal_score\n",
       "0    20183180105  NaN        80.0       80.0        80.0         80.0\n",
       "1    20183180109  NaN        80.0       80.0        80.0         80.0\n",
       "2    20183180122  NaN        80.0       80.0        80.0         80.0\n",
       "3    20183180129  NaN        80.0       80.0        84.0         81.0\n",
       "4    20183180137  NaN        80.0       80.0        80.0         80.0\n",
       "..           ...  ...         ...        ...         ...          ...\n",
       "114  32017120070  杜明旭        82.0       80.0        95.0         85.0\n",
       "115  32017120095  马紫来        81.0       80.0        90.0         83.0\n",
       "116  32017120096  高子轩        80.0       80.0        89.0         83.0\n",
       "117  32017150053  郝雨桐        88.0       80.0        88.0         85.0\n",
       "118  32017150058   龙菁        94.0       80.0        91.0         89.0\n",
       "\n",
       "[119 rows x 6 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.concat([data2, data], axis=1)#连接两个表\n",
    "df.reset_index(inplace=True,drop=False)#重新设置索引 不删除原来的索引\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import csv\n",
    "if not os.path.exists('score1.csv'): \n",
    "    headers = ['Number','name','main_score','123_score','sign_score','tatal_score'] \n",
    "    with open('score1.csv', 'w', newline = '', encoding = 'gbk') as f:  \n",
    "        f_csv = csv.writer(f)  \n",
    "        f_csv.writerow(headers)  \n",
    "with open('score1.csv', 'a', newline = '', encoding = 'gbk') as f:\n",
    "    f_csv = csv.writer(f)  \n",
    "    for index,row in df.iterrows():\n",
    "        f_csv.writerow(row)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "data3=pd.read_csv('score1.csv',encoding='gbk')#读取数据集"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Number</th>\n",
       "      <th>name</th>\n",
       "      <th>main_score</th>\n",
       "      <th>123_score</th>\n",
       "      <th>sign_score</th>\n",
       "      <th>tatal_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20183180105</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20183180109</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20183180122</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>20183180129</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>81.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>20183180137</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>22019207065</td>\n",
       "      <td>张泽远</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>22019208018</td>\n",
       "      <td>王祎</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>22020030091</td>\n",
       "      <td>罗德鑫</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>22020039991</td>\n",
       "      <td>张明明</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>22020110133</td>\n",
       "      <td>李兴超</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>22020120001</td>\n",
       "      <td>王海萍</td>\n",
       "      <td>97.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>22020120002</td>\n",
       "      <td>石倩</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>22020120003</td>\n",
       "      <td>杨婷</td>\n",
       "      <td>98.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>22020120004</td>\n",
       "      <td>郁爱萍</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>22020120006</td>\n",
       "      <td>刘姣</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>22020120009</td>\n",
       "      <td>赵子树</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>22020120010</td>\n",
       "      <td>NaN</td>\n",
       "      <td>81.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>22020120012</td>\n",
       "      <td>王梓晗</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>22020120013</td>\n",
       "      <td>NaN</td>\n",
       "      <td>81.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>81.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>22020120016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>82.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>81.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>22020120018</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22020120024</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>83.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22020120031</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>22020120060</td>\n",
       "      <td>孙可欣</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>22020120073</td>\n",
       "      <td>郭慧鑫</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>22020200015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>82.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>22020210007</td>\n",
       "      <td>张杜鹃</td>\n",
       "      <td>94.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>101.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>22020210008</td>\n",
       "      <td>张旭</td>\n",
       "      <td>88.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>22020210009</td>\n",
       "      <td>张峻杰</td>\n",
       "      <td>88.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>22020210010</td>\n",
       "      <td>武梦笛</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>22020210011</td>\n",
       "      <td>王丽然</td>\n",
       "      <td>90.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>22020210012</td>\n",
       "      <td>张放</td>\n",
       "      <td>89.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>22020210013</td>\n",
       "      <td>李沛璇</td>\n",
       "      <td>92.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>101.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>22020210014</td>\n",
       "      <td>李健博</td>\n",
       "      <td>91.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>22020210015</td>\n",
       "      <td>李夏猗</td>\n",
       "      <td>97.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>22020210016</td>\n",
       "      <td>郭稼乐</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>22020210017</td>\n",
       "      <td>宋昊</td>\n",
       "      <td>97.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>22020210018</td>\n",
       "      <td>王琦</td>\n",
       "      <td>95.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>22020210019</td>\n",
       "      <td>高蝶</td>\n",
       "      <td>88.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>22020210020</td>\n",
       "      <td>刘羽</td>\n",
       "      <td>87.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>22020210021</td>\n",
       "      <td>刘子卓</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>22020210022</td>\n",
       "      <td>毛甫成</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>22020210023</td>\n",
       "      <td>李岚婷</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>22020210024</td>\n",
       "      <td>齐春晖</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>83.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>22020210025</td>\n",
       "      <td>尹彭</td>\n",
       "      <td>90.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>22020210026</td>\n",
       "      <td>赵佳</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>22020210027</td>\n",
       "      <td>单腾飞</td>\n",
       "      <td>90.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>22020210028</td>\n",
       "      <td>时少丹</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>22020210029</td>\n",
       "      <td>韦敬宣</td>\n",
       "      <td>88.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>22020210030</td>\n",
       "      <td>郭佳丽</td>\n",
       "      <td>92.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>22020210031</td>\n",
       "      <td>张鸿伟</td>\n",
       "      <td>87.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>22020210032</td>\n",
       "      <td>贾轩</td>\n",
       "      <td>86.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>22020210033</td>\n",
       "      <td>王汝梦</td>\n",
       "      <td>87.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>22020210035</td>\n",
       "      <td>石如昆</td>\n",
       "      <td>98.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>22020210036</td>\n",
       "      <td>张飞宇</td>\n",
       "      <td>82.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>85.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>22020210037</td>\n",
       "      <td>蔡潇丹</td>\n",
       "      <td>87.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>22020210038</td>\n",
       "      <td>张志宇</td>\n",
       "      <td>92.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>92.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>22020210039</td>\n",
       "      <td>王宇轩</td>\n",
       "      <td>92.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>22020210040</td>\n",
       "      <td>崔明月</td>\n",
       "      <td>82.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>85.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>22020210041</td>\n",
       "      <td>李宗岳</td>\n",
       "      <td>91.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>22020210042</td>\n",
       "      <td>陈立仲</td>\n",
       "      <td>95.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>22020210043</td>\n",
       "      <td>何惠</td>\n",
       "      <td>91.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>22020210044</td>\n",
       "      <td>张劭贤</td>\n",
       "      <td>96.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>22020210045</td>\n",
       "      <td>李翔</td>\n",
       "      <td>96.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>22020210046</td>\n",
       "      <td>余欣明</td>\n",
       "      <td>82.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>22020210047</td>\n",
       "      <td>周春旭</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>22020210048</td>\n",
       "      <td>万宏宇</td>\n",
       "      <td>94.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>22020210049</td>\n",
       "      <td>刘双婷</td>\n",
       "      <td>87.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>22020210050</td>\n",
       "      <td>白曼</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>22020210051</td>\n",
       "      <td>谢磊鹏</td>\n",
       "      <td>90.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>22020210052</td>\n",
       "      <td>刘中飞</td>\n",
       "      <td>88.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>22020210054</td>\n",
       "      <td>封文森</td>\n",
       "      <td>97.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>22020210055</td>\n",
       "      <td>张宇峰</td>\n",
       "      <td>96.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>22020210056</td>\n",
       "      <td>王娇</td>\n",
       "      <td>87.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>22020210084</td>\n",
       "      <td>李睿</td>\n",
       "      <td>95.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>93.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>22020210088</td>\n",
       "      <td>韩文杰</td>\n",
       "      <td>94.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>92.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>22020210091</td>\n",
       "      <td>崔明悦</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>22020210092</td>\n",
       "      <td>吴英丽</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>22020210095</td>\n",
       "      <td>刘昭含</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>22020210096</td>\n",
       "      <td>张广芸</td>\n",
       "      <td>92.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>22020210097</td>\n",
       "      <td>高玉莹</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>22020210099</td>\n",
       "      <td>田光彬</td>\n",
       "      <td>97.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>22020210102</td>\n",
       "      <td>桂启磊</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>22020210103</td>\n",
       "      <td>高忠</td>\n",
       "      <td>94.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>92.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>22020210104</td>\n",
       "      <td>张淑琪</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>22020210105</td>\n",
       "      <td>刘聪</td>\n",
       "      <td>91.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>22020210106</td>\n",
       "      <td>陈冰</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>22020210107</td>\n",
       "      <td>肖瑶</td>\n",
       "      <td>93.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>93.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>22020210109</td>\n",
       "      <td>彭佳</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>22020210110</td>\n",
       "      <td>李梦雪</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>22020210111</td>\n",
       "      <td>胡军</td>\n",
       "      <td>90.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>22020210112</td>\n",
       "      <td>韩鑫</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>22020210113</td>\n",
       "      <td>董欣雨</td>\n",
       "      <td>98.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>22020219991</td>\n",
       "      <td>许慧良</td>\n",
       "      <td>94.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>93.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>32017070001</td>\n",
       "      <td>于鸣霄</td>\n",
       "      <td>82.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>83.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>32017070008</td>\n",
       "      <td>崔家欣</td>\n",
       "      <td>87.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>32017070010</td>\n",
       "      <td>徐晓飞</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>32017070014</td>\n",
       "      <td>曾宪春</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>32017070022</td>\n",
       "      <td>杨雅婷</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>32017070030</td>\n",
       "      <td>王玲月</td>\n",
       "      <td>92.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>32017070033</td>\n",
       "      <td>秦昊堃</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>32017070043</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>82.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>32017070057</td>\n",
       "      <td>吴浩</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>32017070061</td>\n",
       "      <td>张哲宇</td>\n",
       "      <td>83.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>32017070064</td>\n",
       "      <td>张暄杰</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>82.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>32017070079</td>\n",
       "      <td>王瀚</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>32017070086</td>\n",
       "      <td>谭紫荷</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>32017070090</td>\n",
       "      <td>邹远洋</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>82.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>32017070096</td>\n",
       "      <td>颜紫欣</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>32017070097</td>\n",
       "      <td>鹿方圆</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>83.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>32017070139</td>\n",
       "      <td>周冰雪</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>32017110044</td>\n",
       "      <td>张博文</td>\n",
       "      <td>93.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>32017120048</td>\n",
       "      <td>叶芸杉</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>32017120066</td>\n",
       "      <td>李云天</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>32017120070</td>\n",
       "      <td>杜明旭</td>\n",
       "      <td>82.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>32017120095</td>\n",
       "      <td>马紫来</td>\n",
       "      <td>81.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>32017120096</td>\n",
       "      <td>高子轩</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>83.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>32017150053</td>\n",
       "      <td>郝雨桐</td>\n",
       "      <td>88.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>32017150058</td>\n",
       "      <td>龙菁</td>\n",
       "      <td>94.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>92.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Number name  main_score  123_score  sign_score  tatal_score\n",
       "0    20183180105  NaN        80.0       80.0        80.0         80.0\n",
       "1    20183180109  NaN        80.0       80.0        80.0         80.0\n",
       "2    20183180122  NaN        80.0       80.0        80.0         80.0\n",
       "3    20183180129  NaN        80.0       80.0        84.0         81.0\n",
       "4    20183180137  NaN        80.0       80.0        80.0         80.0\n",
       "5    22019207065  张泽远        80.0       80.0        80.0         80.0\n",
       "6    22019208018   王祎        80.0       80.0        80.0         80.0\n",
       "7    22020030091  罗德鑫        98.0       98.0        90.0         95.0\n",
       "8    22020039991  张明明        98.0       98.0        94.0         96.0\n",
       "9    22020110133  李兴超        98.0       94.0        93.0         95.0\n",
       "10   22020120001  王海萍        97.0       93.0        96.0         96.0\n",
       "11   22020120002   石倩        85.0       84.0        95.0         88.0\n",
       "12   22020120003   杨婷        98.0       96.0        97.0         97.0\n",
       "13   22020120004  郁爱萍        84.0       83.0        95.0         87.0\n",
       "14   22020120006   刘姣        85.0       84.0        97.0         88.0\n",
       "15   22020120009  赵子树        84.0       83.0        96.0         87.0\n",
       "16   22020120010  NaN        81.0       80.0        80.0         80.0\n",
       "17   22020120012  王梓晗        98.0       98.0        96.0         97.0\n",
       "18   22020120013  NaN        81.0       81.0        80.0         81.0\n",
       "19   22020120016  NaN        82.0       82.0        80.0         81.0\n",
       "20   22020120018  NaN        80.0       80.0        80.0         80.0\n",
       "21   22020120024  NaN        80.0       80.0        91.0         83.0\n",
       "22   22020120031  NaN        80.0       80.0        80.0         80.0\n",
       "23   22020120060  孙可欣        98.0       94.0        97.0         97.0\n",
       "24   22020120073  郭慧鑫        98.0       98.0        96.0         97.0\n",
       "25   22020200015  NaN        80.0       80.0        88.0         82.0\n",
       "26   22020210007  张杜鹃        94.0       91.0       101.0         95.0\n",
       "27   22020210008   张旭        88.0       86.0        94.0         90.0\n",
       "28   22020210009  张峻杰        88.0       86.0        93.0         89.0\n",
       "29   22020210010  武梦笛        85.0       84.0        97.0         88.0\n",
       "30   22020210011  王丽然        90.0       88.0        88.0         89.0\n",
       "31   22020210012   张放        89.0       87.0        94.0         90.0\n",
       "32   22020210013  李沛璇        92.0       89.0       101.0         94.0\n",
       "33   22020210014  李健博        91.0       88.0        93.0         91.0\n",
       "34   22020210015  李夏猗        97.0       93.0        94.0         95.0\n",
       "35   22020210016  郭稼乐        98.0       98.0        94.0         97.0\n",
       "36   22020210017   宋昊        97.0       93.0        94.0         95.0\n",
       "37   22020210018   王琦        95.0       91.0        94.0         94.0\n",
       "38   22020210019   高蝶        88.0       86.0        97.0         90.0\n",
       "39   22020210020   刘羽        87.0       85.0        96.0         89.0\n",
       "40   22020210021  刘子卓        85.0       84.0        92.0         87.0\n",
       "41   22020210022  毛甫成        98.0       98.0        94.0         97.0\n",
       "42   22020210023  李岚婷        85.0       84.0        93.0         87.0\n",
       "43   22020210024  齐春晖        80.0       80.0        90.0         83.0\n",
       "44   22020210025   尹彭        90.0       87.0        94.0         90.0\n",
       "45   22020210026   赵佳        98.0       94.0        92.0         95.0\n",
       "46   22020210027  单腾飞        90.0       87.0        93.0         90.0\n",
       "47   22020210028  时少丹        98.0       94.0        97.0         96.0\n",
       "48   22020210029  韦敬宣        88.0       86.0        92.0         89.0\n",
       "49   22020210030  郭佳丽        92.0       89.0        99.0         94.0\n",
       "50   22020210031  张鸿伟        87.0       85.0        92.0         88.0\n",
       "51   22020210032   贾轩        86.0       84.0        97.0         89.0\n",
       "52   22020210033  王汝梦        87.0       85.0       100.0         90.0\n",
       "53   22020210035  石如昆        98.0       96.0        97.0         97.0\n",
       "54   22020210036  张飞宇        82.0       81.0        92.0         85.0\n",
       "55   22020210037  蔡潇丹        87.0       85.0        94.0         88.0\n",
       "56   22020210038  张志宇        92.0       89.0        95.0         92.0\n",
       "57   22020210039  王宇轩        92.0       89.0        91.0         91.0\n",
       "58   22020210040  崔明月        82.0       82.0        92.0         85.0\n",
       "59   22020210041  李宗岳        91.0       89.0        92.0         91.0\n",
       "60   22020210042  陈立仲        95.0       92.0        94.0         94.0\n",
       "61   22020210043   何惠        91.0       89.0        94.0         91.0\n",
       "62   22020210044  张劭贤        96.0       92.0        94.0         94.0\n",
       "63   22020210045   李翔        96.0       92.0        95.0         95.0\n",
       "64   22020210046  余欣明        82.0       82.0        96.0         86.0\n",
       "65   22020210047  周春旭        84.0       83.0        92.0         86.0\n",
       "66   22020210048  万宏宇        94.0       90.0        98.0         94.0\n",
       "67   22020210049  刘双婷        87.0       85.0        92.0         88.0\n",
       "68   22020210050   白曼        84.0       83.0        95.0         87.0\n",
       "69   22020210051  谢磊鹏        90.0       87.0        92.0         90.0\n",
       "70   22020210052  刘中飞        88.0       86.0        94.0         89.0\n",
       "71   22020210054  封文森        97.0       93.0        98.0         96.0\n",
       "72   22020210055  张宇峰        96.0       92.0        98.0         95.0\n",
       "73   22020210056   王娇        87.0       85.0        95.0         88.0\n",
       "74   22020210084   李睿        95.0       92.0        92.0         93.0\n",
       "75   22020210088  韩文杰        94.0       91.0        90.0         92.0\n",
       "76   22020210091  崔明悦        98.0       98.0        94.0         96.0\n",
       "77   22020210092  吴英丽        98.0       98.0        95.0         97.0\n",
       "78   22020210095  刘昭含        98.0       98.0        95.0         97.0\n",
       "79   22020210096  张广芸        92.0       89.0        90.0         90.0\n",
       "80   22020210097  高玉莹        98.0       98.0        93.0         96.0\n",
       "81   22020210099  田光彬        97.0       93.0        92.0         94.0\n",
       "82   22020210102  桂启磊        98.0       94.0        92.0         95.0\n",
       "83   22020210103   高忠        94.0       90.0        92.0         92.0\n",
       "84   22020210104  张淑琪        98.0       98.0        96.0         97.0\n",
       "85   22020210105   刘聪        91.0       88.0        95.0         91.0\n",
       "86   22020210106   陈冰        98.0       98.0        94.0         96.0\n",
       "87   22020210107   肖瑶        93.0       90.0        95.0         93.0\n",
       "88   22020210109   彭佳        98.0       98.0        94.0         96.0\n",
       "89   22020210110  李梦雪        98.0       98.0        96.0         97.0\n",
       "90   22020210111   胡军        90.0       87.0        91.0         89.0\n",
       "91   22020210112   韩鑫        98.0       98.0        94.0         96.0\n",
       "92   22020210113  董欣雨        98.0       97.0        95.0         97.0\n",
       "93   22020219991  许慧良        94.0       90.0        95.0         93.0\n",
       "94   32017070001  于鸣霄        82.0       81.0        86.0         83.0\n",
       "95   32017070008  崔家欣        87.0       85.0        93.0         88.0\n",
       "96   32017070010  徐晓飞        85.0       84.0        90.0         86.0\n",
       "97   32017070014  曾宪春         NaN        NaN         NaN          NaN\n",
       "98   32017070022  杨雅婷        84.0       83.0        93.0         87.0\n",
       "99   32017070030  王玲月        92.0       89.0        93.0         91.0\n",
       "100  32017070033  秦昊堃        85.0       84.0        89.0         86.0\n",
       "101  32017070043  NaN        80.0       80.0        88.0         82.0\n",
       "102  32017070057   吴浩        80.0       80.0        93.0         84.0\n",
       "103  32017070061  张哲宇        83.0       82.0        95.0         86.0\n",
       "104  32017070064  张暄杰        80.0       80.0        86.0         82.0\n",
       "105  32017070079   王瀚        85.0       84.0        89.0         86.0\n",
       "106  32017070086  谭紫荷        84.0       83.0        92.0         86.0\n",
       "107  32017070090  邹远洋        80.0       80.0        89.0         82.0\n",
       "108  32017070096  颜紫欣        80.0       80.0        93.0         84.0\n",
       "109  32017070097  鹿方圆        80.0       80.0        92.0         83.0\n",
       "110  32017070139  周冰雪        84.0       83.0        91.0         86.0\n",
       "111  32017110044  张博文        93.0       90.0        91.0         91.0\n",
       "112  32017120048  叶芸杉        85.0       84.0        91.0         87.0\n",
       "113  32017120066  李云天        80.0       80.0        95.0         84.0\n",
       "114  32017120070  杜明旭        82.0       82.0        95.0         86.0\n",
       "115  32017120095  马紫来        81.0       81.0        90.0         84.0\n",
       "116  32017120096  高子轩        80.0       80.0        89.0         83.0\n",
       "117  32017150053  郝雨桐        88.0       86.0        88.0         87.0\n",
       "118  32017150058   龙菁        94.0       91.0        91.0         92.0"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Number</th>\n",
       "      <th>name</th>\n",
       "      <th>main_score</th>\n",
       "      <th>123_score</th>\n",
       "      <th>sign_score</th>\n",
       "      <th>tatal_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>22019207065</td>\n",
       "      <td>张泽远</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>22019208018</td>\n",
       "      <td>王祎</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>22020030091</td>\n",
       "      <td>罗德鑫</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>22020039991</td>\n",
       "      <td>张明明</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>22020110133</td>\n",
       "      <td>李兴超</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>22020120001</td>\n",
       "      <td>王海萍</td>\n",
       "      <td>97.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>22020120002</td>\n",
       "      <td>石倩</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>22020120003</td>\n",
       "      <td>杨婷</td>\n",
       "      <td>98.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>22020120004</td>\n",
       "      <td>郁爱萍</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>22020120006</td>\n",
       "      <td>刘姣</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>22020120009</td>\n",
       "      <td>赵子树</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>22020120012</td>\n",
       "      <td>王梓晗</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>22020120060</td>\n",
       "      <td>孙可欣</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>22020120073</td>\n",
       "      <td>郭慧鑫</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>22020210007</td>\n",
       "      <td>张杜鹃</td>\n",
       "      <td>94.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>101.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>22020210008</td>\n",
       "      <td>张旭</td>\n",
       "      <td>88.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>22020210009</td>\n",
       "      <td>张峻杰</td>\n",
       "      <td>88.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>22020210010</td>\n",
       "      <td>武梦笛</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>22020210011</td>\n",
       "      <td>王丽然</td>\n",
       "      <td>90.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>22020210012</td>\n",
       "      <td>张放</td>\n",
       "      <td>89.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>22020210013</td>\n",
       "      <td>李沛璇</td>\n",
       "      <td>92.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>101.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>22020210014</td>\n",
       "      <td>李健博</td>\n",
       "      <td>91.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>22020210015</td>\n",
       "      <td>李夏猗</td>\n",
       "      <td>97.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>22020210016</td>\n",
       "      <td>郭稼乐</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>22020210017</td>\n",
       "      <td>宋昊</td>\n",
       "      <td>97.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>22020210018</td>\n",
       "      <td>王琦</td>\n",
       "      <td>95.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>22020210019</td>\n",
       "      <td>高蝶</td>\n",
       "      <td>88.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>22020210020</td>\n",
       "      <td>刘羽</td>\n",
       "      <td>87.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>22020210021</td>\n",
       "      <td>刘子卓</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>22020210022</td>\n",
       "      <td>毛甫成</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>22020210023</td>\n",
       "      <td>李岚婷</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>22020210024</td>\n",
       "      <td>齐春晖</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>83.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>22020210025</td>\n",
       "      <td>尹彭</td>\n",
       "      <td>90.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>22020210026</td>\n",
       "      <td>赵佳</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>22020210027</td>\n",
       "      <td>单腾飞</td>\n",
       "      <td>90.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>22020210028</td>\n",
       "      <td>时少丹</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>22020210029</td>\n",
       "      <td>韦敬宣</td>\n",
       "      <td>88.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>22020210030</td>\n",
       "      <td>郭佳丽</td>\n",
       "      <td>92.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>22020210031</td>\n",
       "      <td>张鸿伟</td>\n",
       "      <td>87.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>22020210032</td>\n",
       "      <td>贾轩</td>\n",
       "      <td>86.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>22020210033</td>\n",
       "      <td>王汝梦</td>\n",
       "      <td>87.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>22020210035</td>\n",
       "      <td>石如昆</td>\n",
       "      <td>98.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>22020210036</td>\n",
       "      <td>张飞宇</td>\n",
       "      <td>82.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>85.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>22020210037</td>\n",
       "      <td>蔡潇丹</td>\n",
       "      <td>87.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>22020210038</td>\n",
       "      <td>张志宇</td>\n",
       "      <td>92.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>92.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>22020210039</td>\n",
       "      <td>王宇轩</td>\n",
       "      <td>92.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>22020210040</td>\n",
       "      <td>崔明月</td>\n",
       "      <td>82.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>85.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>22020210041</td>\n",
       "      <td>李宗岳</td>\n",
       "      <td>91.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>22020210042</td>\n",
       "      <td>陈立仲</td>\n",
       "      <td>95.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>22020210043</td>\n",
       "      <td>何惠</td>\n",
       "      <td>91.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>22020210044</td>\n",
       "      <td>张劭贤</td>\n",
       "      <td>96.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>22020210045</td>\n",
       "      <td>李翔</td>\n",
       "      <td>96.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>22020210046</td>\n",
       "      <td>余欣明</td>\n",
       "      <td>82.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>22020210047</td>\n",
       "      <td>周春旭</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>22020210048</td>\n",
       "      <td>万宏宇</td>\n",
       "      <td>94.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>22020210049</td>\n",
       "      <td>刘双婷</td>\n",
       "      <td>87.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>22020210050</td>\n",
       "      <td>白曼</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>22020210051</td>\n",
       "      <td>谢磊鹏</td>\n",
       "      <td>90.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>22020210052</td>\n",
       "      <td>刘中飞</td>\n",
       "      <td>88.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>22020210054</td>\n",
       "      <td>封文森</td>\n",
       "      <td>97.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>22020210055</td>\n",
       "      <td>张宇峰</td>\n",
       "      <td>96.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>22020210056</td>\n",
       "      <td>王娇</td>\n",
       "      <td>87.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>22020210084</td>\n",
       "      <td>李睿</td>\n",
       "      <td>95.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>93.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>22020210088</td>\n",
       "      <td>韩文杰</td>\n",
       "      <td>94.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>92.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>22020210091</td>\n",
       "      <td>崔明悦</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>22020210092</td>\n",
       "      <td>吴英丽</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>22020210095</td>\n",
       "      <td>刘昭含</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>22020210096</td>\n",
       "      <td>张广芸</td>\n",
       "      <td>92.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>22020210097</td>\n",
       "      <td>高玉莹</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>22020210099</td>\n",
       "      <td>田光彬</td>\n",
       "      <td>97.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>22020210102</td>\n",
       "      <td>桂启磊</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>22020210103</td>\n",
       "      <td>高忠</td>\n",
       "      <td>94.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>92.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>22020210104</td>\n",
       "      <td>张淑琪</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>22020210105</td>\n",
       "      <td>刘聪</td>\n",
       "      <td>91.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>22020210106</td>\n",
       "      <td>陈冰</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>22020210107</td>\n",
       "      <td>肖瑶</td>\n",
       "      <td>93.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>93.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>22020210109</td>\n",
       "      <td>彭佳</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>22020210110</td>\n",
       "      <td>李梦雪</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>22020210111</td>\n",
       "      <td>胡军</td>\n",
       "      <td>90.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>22020210112</td>\n",
       "      <td>韩鑫</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>22020210113</td>\n",
       "      <td>董欣雨</td>\n",
       "      <td>98.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>22020219991</td>\n",
       "      <td>许慧良</td>\n",
       "      <td>94.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>93.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>32017070001</td>\n",
       "      <td>于鸣霄</td>\n",
       "      <td>82.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>83.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>32017070008</td>\n",
       "      <td>崔家欣</td>\n",
       "      <td>87.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>32017070010</td>\n",
       "      <td>徐晓飞</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>32017070022</td>\n",
       "      <td>杨雅婷</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>32017070030</td>\n",
       "      <td>王玲月</td>\n",
       "      <td>92.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>32017070033</td>\n",
       "      <td>秦昊堃</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>32017070057</td>\n",
       "      <td>吴浩</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>32017070061</td>\n",
       "      <td>张哲宇</td>\n",
       "      <td>83.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>32017070064</td>\n",
       "      <td>张暄杰</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>82.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>32017070079</td>\n",
       "      <td>王瀚</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>32017070086</td>\n",
       "      <td>谭紫荷</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>32017070090</td>\n",
       "      <td>邹远洋</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>82.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>32017070096</td>\n",
       "      <td>颜紫欣</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>32017070097</td>\n",
       "      <td>鹿方圆</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>83.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>32017070139</td>\n",
       "      <td>周冰雪</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>32017110044</td>\n",
       "      <td>张博文</td>\n",
       "      <td>93.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>32017120048</td>\n",
       "      <td>叶芸杉</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>32017120066</td>\n",
       "      <td>李云天</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>32017120070</td>\n",
       "      <td>杜明旭</td>\n",
       "      <td>82.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>32017120095</td>\n",
       "      <td>马紫来</td>\n",
       "      <td>81.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>32017120096</td>\n",
       "      <td>高子轩</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>83.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>32017150053</td>\n",
       "      <td>郝雨桐</td>\n",
       "      <td>88.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>32017150058</td>\n",
       "      <td>龙菁</td>\n",
       "      <td>94.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>92.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Number name  main_score  123_score  sign_score  tatal_score\n",
       "5    22019207065  张泽远        80.0       80.0        80.0         80.0\n",
       "6    22019208018   王祎        80.0       80.0        80.0         80.0\n",
       "7    22020030091  罗德鑫        98.0       98.0        90.0         95.0\n",
       "8    22020039991  张明明        98.0       98.0        94.0         96.0\n",
       "9    22020110133  李兴超        98.0       94.0        93.0         95.0\n",
       "10   22020120001  王海萍        97.0       93.0        96.0         96.0\n",
       "11   22020120002   石倩        85.0       84.0        95.0         88.0\n",
       "12   22020120003   杨婷        98.0       96.0        97.0         97.0\n",
       "13   22020120004  郁爱萍        84.0       83.0        95.0         87.0\n",
       "14   22020120006   刘姣        85.0       84.0        97.0         88.0\n",
       "15   22020120009  赵子树        84.0       83.0        96.0         87.0\n",
       "17   22020120012  王梓晗        98.0       98.0        96.0         97.0\n",
       "23   22020120060  孙可欣        98.0       94.0        97.0         97.0\n",
       "24   22020120073  郭慧鑫        98.0       98.0        96.0         97.0\n",
       "26   22020210007  张杜鹃        94.0       91.0       101.0         95.0\n",
       "27   22020210008   张旭        88.0       86.0        94.0         90.0\n",
       "28   22020210009  张峻杰        88.0       86.0        93.0         89.0\n",
       "29   22020210010  武梦笛        85.0       84.0        97.0         88.0\n",
       "30   22020210011  王丽然        90.0       88.0        88.0         89.0\n",
       "31   22020210012   张放        89.0       87.0        94.0         90.0\n",
       "32   22020210013  李沛璇        92.0       89.0       101.0         94.0\n",
       "33   22020210014  李健博        91.0       88.0        93.0         91.0\n",
       "34   22020210015  李夏猗        97.0       93.0        94.0         95.0\n",
       "35   22020210016  郭稼乐        98.0       98.0        94.0         97.0\n",
       "36   22020210017   宋昊        97.0       93.0        94.0         95.0\n",
       "37   22020210018   王琦        95.0       91.0        94.0         94.0\n",
       "38   22020210019   高蝶        88.0       86.0        97.0         90.0\n",
       "39   22020210020   刘羽        87.0       85.0        96.0         89.0\n",
       "40   22020210021  刘子卓        85.0       84.0        92.0         87.0\n",
       "41   22020210022  毛甫成        98.0       98.0        94.0         97.0\n",
       "42   22020210023  李岚婷        85.0       84.0        93.0         87.0\n",
       "43   22020210024  齐春晖        80.0       80.0        90.0         83.0\n",
       "44   22020210025   尹彭        90.0       87.0        94.0         90.0\n",
       "45   22020210026   赵佳        98.0       94.0        92.0         95.0\n",
       "46   22020210027  单腾飞        90.0       87.0        93.0         90.0\n",
       "47   22020210028  时少丹        98.0       94.0        97.0         96.0\n",
       "48   22020210029  韦敬宣        88.0       86.0        92.0         89.0\n",
       "49   22020210030  郭佳丽        92.0       89.0        99.0         94.0\n",
       "50   22020210031  张鸿伟        87.0       85.0        92.0         88.0\n",
       "51   22020210032   贾轩        86.0       84.0        97.0         89.0\n",
       "52   22020210033  王汝梦        87.0       85.0       100.0         90.0\n",
       "53   22020210035  石如昆        98.0       96.0        97.0         97.0\n",
       "54   22020210036  张飞宇        82.0       81.0        92.0         85.0\n",
       "55   22020210037  蔡潇丹        87.0       85.0        94.0         88.0\n",
       "56   22020210038  张志宇        92.0       89.0        95.0         92.0\n",
       "57   22020210039  王宇轩        92.0       89.0        91.0         91.0\n",
       "58   22020210040  崔明月        82.0       82.0        92.0         85.0\n",
       "59   22020210041  李宗岳        91.0       89.0        92.0         91.0\n",
       "60   22020210042  陈立仲        95.0       92.0        94.0         94.0\n",
       "61   22020210043   何惠        91.0       89.0        94.0         91.0\n",
       "62   22020210044  张劭贤        96.0       92.0        94.0         94.0\n",
       "63   22020210045   李翔        96.0       92.0        95.0         95.0\n",
       "64   22020210046  余欣明        82.0       82.0        96.0         86.0\n",
       "65   22020210047  周春旭        84.0       83.0        92.0         86.0\n",
       "66   22020210048  万宏宇        94.0       90.0        98.0         94.0\n",
       "67   22020210049  刘双婷        87.0       85.0        92.0         88.0\n",
       "68   22020210050   白曼        84.0       83.0        95.0         87.0\n",
       "69   22020210051  谢磊鹏        90.0       87.0        92.0         90.0\n",
       "70   22020210052  刘中飞        88.0       86.0        94.0         89.0\n",
       "71   22020210054  封文森        97.0       93.0        98.0         96.0\n",
       "72   22020210055  张宇峰        96.0       92.0        98.0         95.0\n",
       "73   22020210056   王娇        87.0       85.0        95.0         88.0\n",
       "74   22020210084   李睿        95.0       92.0        92.0         93.0\n",
       "75   22020210088  韩文杰        94.0       91.0        90.0         92.0\n",
       "76   22020210091  崔明悦        98.0       98.0        94.0         96.0\n",
       "77   22020210092  吴英丽        98.0       98.0        95.0         97.0\n",
       "78   22020210095  刘昭含        98.0       98.0        95.0         97.0\n",
       "79   22020210096  张广芸        92.0       89.0        90.0         90.0\n",
       "80   22020210097  高玉莹        98.0       98.0        93.0         96.0\n",
       "81   22020210099  田光彬        97.0       93.0        92.0         94.0\n",
       "82   22020210102  桂启磊        98.0       94.0        92.0         95.0\n",
       "83   22020210103   高忠        94.0       90.0        92.0         92.0\n",
       "84   22020210104  张淑琪        98.0       98.0        96.0         97.0\n",
       "85   22020210105   刘聪        91.0       88.0        95.0         91.0\n",
       "86   22020210106   陈冰        98.0       98.0        94.0         96.0\n",
       "87   22020210107   肖瑶        93.0       90.0        95.0         93.0\n",
       "88   22020210109   彭佳        98.0       98.0        94.0         96.0\n",
       "89   22020210110  李梦雪        98.0       98.0        96.0         97.0\n",
       "90   22020210111   胡军        90.0       87.0        91.0         89.0\n",
       "91   22020210112   韩鑫        98.0       98.0        94.0         96.0\n",
       "92   22020210113  董欣雨        98.0       97.0        95.0         97.0\n",
       "93   22020219991  许慧良        94.0       90.0        95.0         93.0\n",
       "94   32017070001  于鸣霄        82.0       81.0        86.0         83.0\n",
       "95   32017070008  崔家欣        87.0       85.0        93.0         88.0\n",
       "96   32017070010  徐晓飞        85.0       84.0        90.0         86.0\n",
       "98   32017070022  杨雅婷        84.0       83.0        93.0         87.0\n",
       "99   32017070030  王玲月        92.0       89.0        93.0         91.0\n",
       "100  32017070033  秦昊堃        85.0       84.0        89.0         86.0\n",
       "102  32017070057   吴浩        80.0       80.0        93.0         84.0\n",
       "103  32017070061  张哲宇        83.0       82.0        95.0         86.0\n",
       "104  32017070064  张暄杰        80.0       80.0        86.0         82.0\n",
       "105  32017070079   王瀚        85.0       84.0        89.0         86.0\n",
       "106  32017070086  谭紫荷        84.0       83.0        92.0         86.0\n",
       "107  32017070090  邹远洋        80.0       80.0        89.0         82.0\n",
       "108  32017070096  颜紫欣        80.0       80.0        93.0         84.0\n",
       "109  32017070097  鹿方圆        80.0       80.0        92.0         83.0\n",
       "110  32017070139  周冰雪        84.0       83.0        91.0         86.0\n",
       "111  32017110044  张博文        93.0       90.0        91.0         91.0\n",
       "112  32017120048  叶芸杉        85.0       84.0        91.0         87.0\n",
       "113  32017120066  李云天        80.0       80.0        95.0         84.0\n",
       "114  32017120070  杜明旭        82.0       82.0        95.0         86.0\n",
       "115  32017120095  马紫来        81.0       81.0        90.0         84.0\n",
       "116  32017120096  高子轩        80.0       80.0        89.0         83.0\n",
       "117  32017150053  郝雨桐        88.0       86.0        88.0         87.0\n",
       "118  32017150058   龙菁        94.0       91.0        91.0         92.0"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final=data3.dropna()\n",
    "final"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import csv\n",
    "if not os.path.exists('final_score.csv'): \n",
    "    headers = ['Number','name','main_score','123_score','sign_score','tatal_score'] \n",
    "    with open('final_score.csv', 'w', newline = '', encoding = 'gbk') as f:  \n",
    "        f_csv = csv.writer(f)  \n",
    "        f_csv.writerow(headers)  \n",
    "with open('final_score.csv', 'a', newline = '', encoding = 'gbk') as f:\n",
    "    f_csv = csv.writer(f)  \n",
    "    for index,row in final.iterrows():\n",
    "        f_csv.writerow(row)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Number</th>\n",
       "      <th>name</th>\n",
       "      <th>main_score</th>\n",
       "      <th>123_score</th>\n",
       "      <th>sign_score</th>\n",
       "      <th>tatal_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>22019207065</td>\n",
       "      <td>张泽远</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>22019208018</td>\n",
       "      <td>王祎</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>22020030091</td>\n",
       "      <td>罗德鑫</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>22020039991</td>\n",
       "      <td>张明明</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>22020110133</td>\n",
       "      <td>李兴超</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>22020120001</td>\n",
       "      <td>王海萍</td>\n",
       "      <td>97.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>22020120002</td>\n",
       "      <td>石倩</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>22020120003</td>\n",
       "      <td>杨婷</td>\n",
       "      <td>98.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>22020120004</td>\n",
       "      <td>郁爱萍</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>22020120006</td>\n",
       "      <td>刘姣</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>22020120009</td>\n",
       "      <td>赵子树</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>22020120012</td>\n",
       "      <td>王梓晗</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>22020120060</td>\n",
       "      <td>孙可欣</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>22020120073</td>\n",
       "      <td>郭慧鑫</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>22020210007</td>\n",
       "      <td>张杜鹃</td>\n",
       "      <td>94.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>101.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>22020210008</td>\n",
       "      <td>张旭</td>\n",
       "      <td>88.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>22020210009</td>\n",
       "      <td>张峻杰</td>\n",
       "      <td>88.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>22020210010</td>\n",
       "      <td>武梦笛</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>22020210011</td>\n",
       "      <td>王丽然</td>\n",
       "      <td>90.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>22020210012</td>\n",
       "      <td>张放</td>\n",
       "      <td>89.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>22020210013</td>\n",
       "      <td>李沛璇</td>\n",
       "      <td>92.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>101.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22020210014</td>\n",
       "      <td>李健博</td>\n",
       "      <td>91.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22020210015</td>\n",
       "      <td>李夏猗</td>\n",
       "      <td>97.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>22020210016</td>\n",
       "      <td>郭稼乐</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>22020210017</td>\n",
       "      <td>宋昊</td>\n",
       "      <td>97.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>22020210018</td>\n",
       "      <td>王琦</td>\n",
       "      <td>95.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>22020210019</td>\n",
       "      <td>高蝶</td>\n",
       "      <td>88.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>22020210020</td>\n",
       "      <td>刘羽</td>\n",
       "      <td>87.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>22020210021</td>\n",
       "      <td>刘子卓</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>22020210022</td>\n",
       "      <td>毛甫成</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>22020210023</td>\n",
       "      <td>李岚婷</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>22020210024</td>\n",
       "      <td>齐春晖</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>83.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>22020210025</td>\n",
       "      <td>尹彭</td>\n",
       "      <td>90.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>22020210026</td>\n",
       "      <td>赵佳</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>22020210027</td>\n",
       "      <td>单腾飞</td>\n",
       "      <td>90.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>22020210028</td>\n",
       "      <td>时少丹</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>22020210029</td>\n",
       "      <td>韦敬宣</td>\n",
       "      <td>88.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>22020210030</td>\n",
       "      <td>郭佳丽</td>\n",
       "      <td>92.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>22020210031</td>\n",
       "      <td>张鸿伟</td>\n",
       "      <td>87.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>22020210032</td>\n",
       "      <td>贾轩</td>\n",
       "      <td>86.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>22020210033</td>\n",
       "      <td>王汝梦</td>\n",
       "      <td>87.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>22020210035</td>\n",
       "      <td>石如昆</td>\n",
       "      <td>98.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>22020210036</td>\n",
       "      <td>张飞宇</td>\n",
       "      <td>82.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>85.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>22020210037</td>\n",
       "      <td>蔡潇丹</td>\n",
       "      <td>87.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>22020210038</td>\n",
       "      <td>张志宇</td>\n",
       "      <td>92.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>92.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>22020210039</td>\n",
       "      <td>王宇轩</td>\n",
       "      <td>92.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>22020210040</td>\n",
       "      <td>崔明月</td>\n",
       "      <td>82.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>85.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>22020210041</td>\n",
       "      <td>李宗岳</td>\n",
       "      <td>91.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>22020210042</td>\n",
       "      <td>陈立仲</td>\n",
       "      <td>95.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>22020210043</td>\n",
       "      <td>何惠</td>\n",
       "      <td>91.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>22020210044</td>\n",
       "      <td>张劭贤</td>\n",
       "      <td>96.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>22020210045</td>\n",
       "      <td>李翔</td>\n",
       "      <td>96.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>22020210046</td>\n",
       "      <td>余欣明</td>\n",
       "      <td>82.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>22020210047</td>\n",
       "      <td>周春旭</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>22020210048</td>\n",
       "      <td>万宏宇</td>\n",
       "      <td>94.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>22020210049</td>\n",
       "      <td>刘双婷</td>\n",
       "      <td>87.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>22020210050</td>\n",
       "      <td>白曼</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>22020210051</td>\n",
       "      <td>谢磊鹏</td>\n",
       "      <td>90.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>22020210052</td>\n",
       "      <td>刘中飞</td>\n",
       "      <td>88.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>22020210054</td>\n",
       "      <td>封文森</td>\n",
       "      <td>97.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>22020210055</td>\n",
       "      <td>张宇峰</td>\n",
       "      <td>96.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>22020210056</td>\n",
       "      <td>王娇</td>\n",
       "      <td>87.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>22020210084</td>\n",
       "      <td>李睿</td>\n",
       "      <td>95.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>93.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>22020210088</td>\n",
       "      <td>韩文杰</td>\n",
       "      <td>94.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>92.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>22020210091</td>\n",
       "      <td>崔明悦</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>22020210092</td>\n",
       "      <td>吴英丽</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>22020210095</td>\n",
       "      <td>刘昭含</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>22020210096</td>\n",
       "      <td>张广芸</td>\n",
       "      <td>92.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>22020210097</td>\n",
       "      <td>高玉莹</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>22020210099</td>\n",
       "      <td>田光彬</td>\n",
       "      <td>97.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>22020210102</td>\n",
       "      <td>桂启磊</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>95.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>22020210103</td>\n",
       "      <td>高忠</td>\n",
       "      <td>94.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>92.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>22020210104</td>\n",
       "      <td>张淑琪</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>22020210105</td>\n",
       "      <td>刘聪</td>\n",
       "      <td>91.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>22020210106</td>\n",
       "      <td>陈冰</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>22020210107</td>\n",
       "      <td>肖瑶</td>\n",
       "      <td>93.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>93.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>22020210109</td>\n",
       "      <td>彭佳</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>22020210110</td>\n",
       "      <td>李梦雪</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>22020210111</td>\n",
       "      <td>胡军</td>\n",
       "      <td>90.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>22020210112</td>\n",
       "      <td>韩鑫</td>\n",
       "      <td>98.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>22020210113</td>\n",
       "      <td>董欣雨</td>\n",
       "      <td>98.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>22020219991</td>\n",
       "      <td>许慧良</td>\n",
       "      <td>94.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>93.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>32017070001</td>\n",
       "      <td>于鸣霄</td>\n",
       "      <td>82.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>83.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>32017070008</td>\n",
       "      <td>崔家欣</td>\n",
       "      <td>87.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>32017070010</td>\n",
       "      <td>徐晓飞</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>32017070022</td>\n",
       "      <td>杨雅婷</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>32017070030</td>\n",
       "      <td>王玲月</td>\n",
       "      <td>92.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>32017070033</td>\n",
       "      <td>秦昊堃</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>32017070057</td>\n",
       "      <td>吴浩</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>32017070061</td>\n",
       "      <td>张哲宇</td>\n",
       "      <td>83.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>32017070064</td>\n",
       "      <td>张暄杰</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>82.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>32017070079</td>\n",
       "      <td>王瀚</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>32017070086</td>\n",
       "      <td>谭紫荷</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>32017070090</td>\n",
       "      <td>邹远洋</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>82.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>32017070096</td>\n",
       "      <td>颜紫欣</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>32017070097</td>\n",
       "      <td>鹿方圆</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>83.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>32017070139</td>\n",
       "      <td>周冰雪</td>\n",
       "      <td>84.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>32017110044</td>\n",
       "      <td>张博文</td>\n",
       "      <td>93.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>32017120048</td>\n",
       "      <td>叶芸杉</td>\n",
       "      <td>85.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>32017120066</td>\n",
       "      <td>李云天</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>32017120070</td>\n",
       "      <td>杜明旭</td>\n",
       "      <td>82.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>86.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>32017120095</td>\n",
       "      <td>马紫来</td>\n",
       "      <td>81.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>32017120096</td>\n",
       "      <td>高子轩</td>\n",
       "      <td>80.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>83.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>32017150053</td>\n",
       "      <td>郝雨桐</td>\n",
       "      <td>88.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>32017150058</td>\n",
       "      <td>龙菁</td>\n",
       "      <td>94.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>92.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Number name  main_score  123_score  sign_score  tatal_score\n",
       "0    22019207065  张泽远        80.0       80.0        80.0         80.0\n",
       "1    22019208018   王祎        80.0       80.0        80.0         80.0\n",
       "2    22020030091  罗德鑫        98.0       98.0        90.0         95.0\n",
       "3    22020039991  张明明        98.0       98.0        94.0         96.0\n",
       "4    22020110133  李兴超        98.0       94.0        93.0         95.0\n",
       "5    22020120001  王海萍        97.0       93.0        96.0         96.0\n",
       "6    22020120002   石倩        85.0       84.0        95.0         88.0\n",
       "7    22020120003   杨婷        98.0       96.0        97.0         97.0\n",
       "8    22020120004  郁爱萍        84.0       83.0        95.0         87.0\n",
       "9    22020120006   刘姣        85.0       84.0        97.0         88.0\n",
       "10   22020120009  赵子树        84.0       83.0        96.0         87.0\n",
       "11   22020120012  王梓晗        98.0       98.0        96.0         97.0\n",
       "12   22020120060  孙可欣        98.0       94.0        97.0         97.0\n",
       "13   22020120073  郭慧鑫        98.0       98.0        96.0         97.0\n",
       "14   22020210007  张杜鹃        94.0       91.0       101.0         95.0\n",
       "15   22020210008   张旭        88.0       86.0        94.0         90.0\n",
       "16   22020210009  张峻杰        88.0       86.0        93.0         89.0\n",
       "17   22020210010  武梦笛        85.0       84.0        97.0         88.0\n",
       "18   22020210011  王丽然        90.0       88.0        88.0         89.0\n",
       "19   22020210012   张放        89.0       87.0        94.0         90.0\n",
       "20   22020210013  李沛璇        92.0       89.0       101.0         94.0\n",
       "21   22020210014  李健博        91.0       88.0        93.0         91.0\n",
       "22   22020210015  李夏猗        97.0       93.0        94.0         95.0\n",
       "23   22020210016  郭稼乐        98.0       98.0        94.0         97.0\n",
       "24   22020210017   宋昊        97.0       93.0        94.0         95.0\n",
       "25   22020210018   王琦        95.0       91.0        94.0         94.0\n",
       "26   22020210019   高蝶        88.0       86.0        97.0         90.0\n",
       "27   22020210020   刘羽        87.0       85.0        96.0         89.0\n",
       "28   22020210021  刘子卓        85.0       84.0        92.0         87.0\n",
       "29   22020210022  毛甫成        98.0       98.0        94.0         97.0\n",
       "30   22020210023  李岚婷        85.0       84.0        93.0         87.0\n",
       "31   22020210024  齐春晖        80.0       80.0        90.0         83.0\n",
       "32   22020210025   尹彭        90.0       87.0        94.0         90.0\n",
       "33   22020210026   赵佳        98.0       94.0        92.0         95.0\n",
       "34   22020210027  单腾飞        90.0       87.0        93.0         90.0\n",
       "35   22020210028  时少丹        98.0       94.0        97.0         96.0\n",
       "36   22020210029  韦敬宣        88.0       86.0        92.0         89.0\n",
       "37   22020210030  郭佳丽        92.0       89.0        99.0         94.0\n",
       "38   22020210031  张鸿伟        87.0       85.0        92.0         88.0\n",
       "39   22020210032   贾轩        86.0       84.0        97.0         89.0\n",
       "40   22020210033  王汝梦        87.0       85.0       100.0         90.0\n",
       "41   22020210035  石如昆        98.0       96.0        97.0         97.0\n",
       "42   22020210036  张飞宇        82.0       81.0        92.0         85.0\n",
       "43   22020210037  蔡潇丹        87.0       85.0        94.0         88.0\n",
       "44   22020210038  张志宇        92.0       89.0        95.0         92.0\n",
       "45   22020210039  王宇轩        92.0       89.0        91.0         91.0\n",
       "46   22020210040  崔明月        82.0       82.0        92.0         85.0\n",
       "47   22020210041  李宗岳        91.0       89.0        92.0         91.0\n",
       "48   22020210042  陈立仲        95.0       92.0        94.0         94.0\n",
       "49   22020210043   何惠        91.0       89.0        94.0         91.0\n",
       "50   22020210044  张劭贤        96.0       92.0        94.0         94.0\n",
       "51   22020210045   李翔        96.0       92.0        95.0         95.0\n",
       "52   22020210046  余欣明        82.0       82.0        96.0         86.0\n",
       "53   22020210047  周春旭        84.0       83.0        92.0         86.0\n",
       "54   22020210048  万宏宇        94.0       90.0        98.0         94.0\n",
       "55   22020210049  刘双婷        87.0       85.0        92.0         88.0\n",
       "56   22020210050   白曼        84.0       83.0        95.0         87.0\n",
       "57   22020210051  谢磊鹏        90.0       87.0        92.0         90.0\n",
       "58   22020210052  刘中飞        88.0       86.0        94.0         89.0\n",
       "59   22020210054  封文森        97.0       93.0        98.0         96.0\n",
       "60   22020210055  张宇峰        96.0       92.0        98.0         95.0\n",
       "61   22020210056   王娇        87.0       85.0        95.0         88.0\n",
       "62   22020210084   李睿        95.0       92.0        92.0         93.0\n",
       "63   22020210088  韩文杰        94.0       91.0        90.0         92.0\n",
       "64   22020210091  崔明悦        98.0       98.0        94.0         96.0\n",
       "65   22020210092  吴英丽        98.0       98.0        95.0         97.0\n",
       "66   22020210095  刘昭含        98.0       98.0        95.0         97.0\n",
       "67   22020210096  张广芸        92.0       89.0        90.0         90.0\n",
       "68   22020210097  高玉莹        98.0       98.0        93.0         96.0\n",
       "69   22020210099  田光彬        97.0       93.0        92.0         94.0\n",
       "70   22020210102  桂启磊        98.0       94.0        92.0         95.0\n",
       "71   22020210103   高忠        94.0       90.0        92.0         92.0\n",
       "72   22020210104  张淑琪        98.0       98.0        96.0         97.0\n",
       "73   22020210105   刘聪        91.0       88.0        95.0         91.0\n",
       "74   22020210106   陈冰        98.0       98.0        94.0         96.0\n",
       "75   22020210107   肖瑶        93.0       90.0        95.0         93.0\n",
       "76   22020210109   彭佳        98.0       98.0        94.0         96.0\n",
       "77   22020210110  李梦雪        98.0       98.0        96.0         97.0\n",
       "78   22020210111   胡军        90.0       87.0        91.0         89.0\n",
       "79   22020210112   韩鑫        98.0       98.0        94.0         96.0\n",
       "80   22020210113  董欣雨        98.0       97.0        95.0         97.0\n",
       "81   22020219991  许慧良        94.0       90.0        95.0         93.0\n",
       "82   32017070001  于鸣霄        82.0       81.0        86.0         83.0\n",
       "83   32017070008  崔家欣        87.0       85.0        93.0         88.0\n",
       "84   32017070010  徐晓飞        85.0       84.0        90.0         86.0\n",
       "85   32017070022  杨雅婷        84.0       83.0        93.0         87.0\n",
       "86   32017070030  王玲月        92.0       89.0        93.0         91.0\n",
       "87   32017070033  秦昊堃        85.0       84.0        89.0         86.0\n",
       "88   32017070057   吴浩        80.0       80.0        93.0         84.0\n",
       "89   32017070061  张哲宇        83.0       82.0        95.0         86.0\n",
       "90   32017070064  张暄杰        80.0       80.0        86.0         82.0\n",
       "91   32017070079   王瀚        85.0       84.0        89.0         86.0\n",
       "92   32017070086  谭紫荷        84.0       83.0        92.0         86.0\n",
       "93   32017070090  邹远洋        80.0       80.0        89.0         82.0\n",
       "94   32017070096  颜紫欣        80.0       80.0        93.0         84.0\n",
       "95   32017070097  鹿方圆        80.0       80.0        92.0         83.0\n",
       "96   32017070139  周冰雪        84.0       83.0        91.0         86.0\n",
       "97   32017110044  张博文        93.0       90.0        91.0         91.0\n",
       "98   32017120048  叶芸杉        85.0       84.0        91.0         87.0\n",
       "99   32017120066  李云天        80.0       80.0        95.0         84.0\n",
       "100  32017120070  杜明旭        82.0       82.0        95.0         86.0\n",
       "101  32017120095  马紫来        81.0       81.0        90.0         84.0\n",
       "102  32017120096  高子轩        80.0       80.0        89.0         83.0\n",
       "103  32017150053  郝雨桐        88.0       86.0        88.0         87.0\n",
       "104  32017150058   龙菁        94.0       91.0        91.0         92.0"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data4=pd.read_csv('final_score.csv',encoding='gbk')#读取数据集\n",
    "data4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Number</th>\n",
       "      <th>Name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>22019207065</td>\n",
       "      <td>张泽远</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>22019208018</td>\n",
       "      <td>王祎</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>22020210084</td>\n",
       "      <td>李睿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>22020210088</td>\n",
       "      <td>韩文杰</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>22020210091</td>\n",
       "      <td>崔明悦</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>22020210092</td>\n",
       "      <td>吴英丽</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>22020210095</td>\n",
       "      <td>刘昭含</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>22020210096</td>\n",
       "      <td>张广芸</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>22020210097</td>\n",
       "      <td>高玉莹</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>22020210099</td>\n",
       "      <td>田光彬</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>22020210102</td>\n",
       "      <td>桂启磊</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>22020210103</td>\n",
       "      <td>高忠</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>22020210104</td>\n",
       "      <td>张淑琪</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>22020210105</td>\n",
       "      <td>刘聪</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>22020210106</td>\n",
       "      <td>陈冰</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>22020210107</td>\n",
       "      <td>肖瑶</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>22020210109</td>\n",
       "      <td>彭佳</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>22020210110</td>\n",
       "      <td>李梦雪</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>22020210111</td>\n",
       "      <td>胡军</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>22020210112</td>\n",
       "      <td>韩鑫</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>22020210113</td>\n",
       "      <td>董欣雨</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22020030091</td>\n",
       "      <td>罗德鑫</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22020039991</td>\n",
       "      <td>张明明</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>22020110133</td>\n",
       "      <td>李兴超</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>22020120001</td>\n",
       "      <td>王海萍</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>22020120002</td>\n",
       "      <td>石倩</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>22020120003</td>\n",
       "      <td>杨婷</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>22020120004</td>\n",
       "      <td>郁爱萍</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>22020120006</td>\n",
       "      <td>刘姣</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>22020120009</td>\n",
       "      <td>赵子树</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>22020120012</td>\n",
       "      <td>王梓晗</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>22020120060</td>\n",
       "      <td>孙可欣</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>22020120073</td>\n",
       "      <td>郭慧鑫</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>22020210007</td>\n",
       "      <td>张杜鹃</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>22020210008</td>\n",
       "      <td>张旭</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>22020210009</td>\n",
       "      <td>张峻杰</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>22020210010</td>\n",
       "      <td>武梦笛</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>22020210011</td>\n",
       "      <td>王丽然</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>22020210012</td>\n",
       "      <td>张放</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>22020210013</td>\n",
       "      <td>李沛璇</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>22020210014</td>\n",
       "      <td>李健博</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>22020210015</td>\n",
       "      <td>李夏猗</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>22020210016</td>\n",
       "      <td>郭稼乐</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>22020210017</td>\n",
       "      <td>宋昊</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>22020210018</td>\n",
       "      <td>王琦</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>22020210019</td>\n",
       "      <td>高蝶</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>22020210020</td>\n",
       "      <td>刘羽</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>22020210021</td>\n",
       "      <td>刘子卓</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>22020210022</td>\n",
       "      <td>毛甫成</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>22020210023</td>\n",
       "      <td>李岚婷</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>22020210024</td>\n",
       "      <td>齐春晖</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>22020210025</td>\n",
       "      <td>尹彭</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>22020210026</td>\n",
       "      <td>赵佳</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>22020210027</td>\n",
       "      <td>单腾飞</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>22020210028</td>\n",
       "      <td>时少丹</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>22020210029</td>\n",
       "      <td>韦敬宣</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>22020210030</td>\n",
       "      <td>郭佳丽</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>22020210031</td>\n",
       "      <td>张鸿伟</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>22020210035</td>\n",
       "      <td>石如昆</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>22020210050</td>\n",
       "      <td>白曼</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>22020210056</td>\n",
       "      <td>王娇</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>22020219991</td>\n",
       "      <td>许慧良</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>22020210032</td>\n",
       "      <td>贾轩</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>22020210033</td>\n",
       "      <td>王汝梦</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>22020210036</td>\n",
       "      <td>张飞宇</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>22020210037</td>\n",
       "      <td>蔡潇丹</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>22020210038</td>\n",
       "      <td>张志宇</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>22020210039</td>\n",
       "      <td>王宇轩</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>22020210040</td>\n",
       "      <td>崔明月</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>22020210041</td>\n",
       "      <td>李宗岳</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>22020210042</td>\n",
       "      <td>陈立仲</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>22020210043</td>\n",
       "      <td>何惠</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>22020210044</td>\n",
       "      <td>张劭贤</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>22020210045</td>\n",
       "      <td>李翔</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>22020210046</td>\n",
       "      <td>余欣明</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>22020210047</td>\n",
       "      <td>周春旭</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>22020210048</td>\n",
       "      <td>万宏宇</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>22020210049</td>\n",
       "      <td>刘双婷</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>22020210051</td>\n",
       "      <td>谢磊鹏</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>22020210052</td>\n",
       "      <td>刘中飞</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>22020210054</td>\n",
       "      <td>封文森</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>22020210055</td>\n",
       "      <td>张宇峰</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>32017070001</td>\n",
       "      <td>于鸣霄</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>32017070008</td>\n",
       "      <td>崔家欣</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>32017070010</td>\n",
       "      <td>徐晓飞</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>32017070014</td>\n",
       "      <td>曾宪春</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>32017070022</td>\n",
       "      <td>杨雅婷</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>32017070030</td>\n",
       "      <td>王玲月</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>32017070033</td>\n",
       "      <td>秦昊堃</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>32017070057</td>\n",
       "      <td>吴浩</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>32017070061</td>\n",
       "      <td>张哲宇</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>32017070064</td>\n",
       "      <td>张暄杰</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>32017070079</td>\n",
       "      <td>王瀚</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>32017070086</td>\n",
       "      <td>谭紫荷</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>32017070090</td>\n",
       "      <td>邹远洋</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>32017070096</td>\n",
       "      <td>颜紫欣</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>32017070097</td>\n",
       "      <td>鹿方圆</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>32017070139</td>\n",
       "      <td>周冰雪</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>32017110044</td>\n",
       "      <td>张博文</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>32017120048</td>\n",
       "      <td>叶芸杉</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>32017120066</td>\n",
       "      <td>李云天</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>32017120070</td>\n",
       "      <td>杜明旭</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>32017120095</td>\n",
       "      <td>马紫来</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>32017120096</td>\n",
       "      <td>高子轩</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>32017150053</td>\n",
       "      <td>郝雨桐</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>32017150058</td>\n",
       "      <td>龙菁</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Number Name\n",
       "0    22019207065  张泽远\n",
       "1    22019208018   王祎\n",
       "2    22020210084   李睿\n",
       "3    22020210088  韩文杰\n",
       "4    22020210091  崔明悦\n",
       "5    22020210092  吴英丽\n",
       "6    22020210095  刘昭含\n",
       "7    22020210096  张广芸\n",
       "8    22020210097  高玉莹\n",
       "9    22020210099  田光彬\n",
       "10   22020210102  桂启磊\n",
       "11   22020210103   高忠\n",
       "12   22020210104  张淑琪\n",
       "13   22020210105   刘聪\n",
       "14   22020210106   陈冰\n",
       "15   22020210107   肖瑶\n",
       "16   22020210109   彭佳\n",
       "17   22020210110  李梦雪\n",
       "18   22020210111   胡军\n",
       "19   22020210112   韩鑫\n",
       "20   22020210113  董欣雨\n",
       "21   22020030091  罗德鑫\n",
       "22   22020039991  张明明\n",
       "23   22020110133  李兴超\n",
       "24   22020120001  王海萍\n",
       "25   22020120002   石倩\n",
       "26   22020120003   杨婷\n",
       "27   22020120004  郁爱萍\n",
       "28   22020120006   刘姣\n",
       "29   22020120009  赵子树\n",
       "30   22020120012  王梓晗\n",
       "31   22020120060  孙可欣\n",
       "32   22020120073  郭慧鑫\n",
       "33   22020210007  张杜鹃\n",
       "34   22020210008   张旭\n",
       "35   22020210009  张峻杰\n",
       "36   22020210010  武梦笛\n",
       "37   22020210011  王丽然\n",
       "38   22020210012   张放\n",
       "39   22020210013  李沛璇\n",
       "40   22020210014  李健博\n",
       "41   22020210015  李夏猗\n",
       "42   22020210016  郭稼乐\n",
       "43   22020210017   宋昊\n",
       "44   22020210018   王琦\n",
       "45   22020210019   高蝶\n",
       "46   22020210020   刘羽\n",
       "47   22020210021  刘子卓\n",
       "48   22020210022  毛甫成\n",
       "49   22020210023  李岚婷\n",
       "50   22020210024  齐春晖\n",
       "51   22020210025   尹彭\n",
       "52   22020210026   赵佳\n",
       "53   22020210027  单腾飞\n",
       "54   22020210028  时少丹\n",
       "55   22020210029  韦敬宣\n",
       "56   22020210030  郭佳丽\n",
       "57   22020210031  张鸿伟\n",
       "58   22020210035  石如昆\n",
       "59   22020210050   白曼\n",
       "60   22020210056   王娇\n",
       "61   22020219991  许慧良\n",
       "62   22020210032   贾轩\n",
       "63   22020210033  王汝梦\n",
       "64   22020210036  张飞宇\n",
       "65   22020210037  蔡潇丹\n",
       "66   22020210038  张志宇\n",
       "67   22020210039  王宇轩\n",
       "68   22020210040  崔明月\n",
       "69   22020210041  李宗岳\n",
       "70   22020210042  陈立仲\n",
       "71   22020210043   何惠\n",
       "72   22020210044  张劭贤\n",
       "73   22020210045   李翔\n",
       "74   22020210046  余欣明\n",
       "75   22020210047  周春旭\n",
       "76   22020210048  万宏宇\n",
       "77   22020210049  刘双婷\n",
       "78   22020210051  谢磊鹏\n",
       "79   22020210052  刘中飞\n",
       "80   22020210054  封文森\n",
       "81   22020210055  张宇峰\n",
       "82   32017070001  于鸣霄\n",
       "83   32017070008  崔家欣\n",
       "84   32017070010  徐晓飞\n",
       "85   32017070014  曾宪春\n",
       "86   32017070022  杨雅婷\n",
       "87   32017070030  王玲月\n",
       "88   32017070033  秦昊堃\n",
       "89   32017070057   吴浩\n",
       "90   32017070061  张哲宇\n",
       "91   32017070064  张暄杰\n",
       "92   32017070079   王瀚\n",
       "93   32017070086  谭紫荷\n",
       "94   32017070090  邹远洋\n",
       "95   32017070096  颜紫欣\n",
       "96   32017070097  鹿方圆\n",
       "97   32017070139  周冰雪\n",
       "98   32017110044  张博文\n",
       "99   32017120048  叶芸杉\n",
       "100  32017120066  李云天\n",
       "101  32017120070  杜明旭\n",
       "102  32017120095  马紫来\n",
       "103  32017120096  高子轩\n",
       "104  32017150053  郝雨桐\n",
       "105  32017150058   龙菁"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data5=pd.read_csv('num.csv',encoding='gbk')#读取数据集\n",
    "data5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Number</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Name</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>张泽远</th>\n",
       "      <td>22019207065</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>王祎</th>\n",
       "      <td>22019208018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>李睿</th>\n",
       "      <td>22020210084</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>韩文杰</th>\n",
       "      <td>22020210088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>崔明悦</th>\n",
       "      <td>22020210091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>吴英丽</th>\n",
       "      <td>22020210092</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>刘昭含</th>\n",
       "      <td>22020210095</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>张广芸</th>\n",
       "      <td>22020210096</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>高玉莹</th>\n",
       "      <td>22020210097</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>田光彬</th>\n",
       "      <td>22020210099</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>桂启磊</th>\n",
       "      <td>22020210102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>高忠</th>\n",
       "      <td>22020210103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>张淑琪</th>\n",
       "      <td>22020210104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>刘聪</th>\n",
       "      <td>22020210105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>陈冰</th>\n",
       "      <td>22020210106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>肖瑶</th>\n",
       "      <td>22020210107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>彭佳</th>\n",
       "      <td>22020210109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>李梦雪</th>\n",
       "      <td>22020210110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>胡军</th>\n",
       "      <td>22020210111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>韩鑫</th>\n",
       "      <td>22020210112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>董欣雨</th>\n",
       "      <td>22020210113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>罗德鑫</th>\n",
       "      <td>22020030091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>张明明</th>\n",
       "      <td>22020039991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>李兴超</th>\n",
       "      <td>22020110133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>王海萍</th>\n",
       "      <td>22020120001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>石倩</th>\n",
       "      <td>22020120002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>杨婷</th>\n",
       "      <td>22020120003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>郁爱萍</th>\n",
       "      <td>22020120004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>刘姣</th>\n",
       "      <td>22020120006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>赵子树</th>\n",
       "      <td>22020120009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>王梓晗</th>\n",
       "      <td>22020120012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>孙可欣</th>\n",
       "      <td>22020120060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>郭慧鑫</th>\n",
       "      <td>22020120073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>张杜鹃</th>\n",
       "      <td>22020210007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>张旭</th>\n",
       "      <td>22020210008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>张峻杰</th>\n",
       "      <td>22020210009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>武梦笛</th>\n",
       "      <td>22020210010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>王丽然</th>\n",
       "      <td>22020210011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>张放</th>\n",
       "      <td>22020210012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>李沛璇</th>\n",
       "      <td>22020210013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>李健博</th>\n",
       "      <td>22020210014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>李夏猗</th>\n",
       "      <td>22020210015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>郭稼乐</th>\n",
       "      <td>22020210016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>宋昊</th>\n",
       "      <td>22020210017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>王琦</th>\n",
       "      <td>22020210018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>高蝶</th>\n",
       "      <td>22020210019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>刘羽</th>\n",
       "      <td>22020210020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>刘子卓</th>\n",
       "      <td>22020210021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>毛甫成</th>\n",
       "      <td>22020210022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>李岚婷</th>\n",
       "      <td>22020210023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>齐春晖</th>\n",
       "      <td>22020210024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>尹彭</th>\n",
       "      <td>22020210025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>赵佳</th>\n",
       "      <td>22020210026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>单腾飞</th>\n",
       "      <td>22020210027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>时少丹</th>\n",
       "      <td>22020210028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>韦敬宣</th>\n",
       "      <td>22020210029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>郭佳丽</th>\n",
       "      <td>22020210030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>张鸿伟</th>\n",
       "      <td>22020210031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>石如昆</th>\n",
       "      <td>22020210035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>白曼</th>\n",
       "      <td>22020210050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>王娇</th>\n",
       "      <td>22020210056</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>许慧良</th>\n",
       "      <td>22020219991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>贾轩</th>\n",
       "      <td>22020210032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>王汝梦</th>\n",
       "      <td>22020210033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>张飞宇</th>\n",
       "      <td>22020210036</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>蔡潇丹</th>\n",
       "      <td>22020210037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>张志宇</th>\n",
       "      <td>22020210038</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>王宇轩</th>\n",
       "      <td>22020210039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>崔明月</th>\n",
       "      <td>22020210040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>李宗岳</th>\n",
       "      <td>22020210041</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>陈立仲</th>\n",
       "      <td>22020210042</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>何惠</th>\n",
       "      <td>22020210043</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>张劭贤</th>\n",
       "      <td>22020210044</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>李翔</th>\n",
       "      <td>22020210045</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>余欣明</th>\n",
       "      <td>22020210046</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>周春旭</th>\n",
       "      <td>22020210047</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>万宏宇</th>\n",
       "      <td>22020210048</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>刘双婷</th>\n",
       "      <td>22020210049</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>谢磊鹏</th>\n",
       "      <td>22020210051</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>刘中飞</th>\n",
       "      <td>22020210052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>封文森</th>\n",
       "      <td>22020210054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>张宇峰</th>\n",
       "      <td>22020210055</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>于鸣霄</th>\n",
       "      <td>32017070001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>崔家欣</th>\n",
       "      <td>32017070008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>徐晓飞</th>\n",
       "      <td>32017070010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>曾宪春</th>\n",
       "      <td>32017070014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>杨雅婷</th>\n",
       "      <td>32017070022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>王玲月</th>\n",
       "      <td>32017070030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>秦昊堃</th>\n",
       "      <td>32017070033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>吴浩</th>\n",
       "      <td>32017070057</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>张哲宇</th>\n",
       "      <td>32017070061</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>张暄杰</th>\n",
       "      <td>32017070064</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>王瀚</th>\n",
       "      <td>32017070079</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>谭紫荷</th>\n",
       "      <td>32017070086</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>邹远洋</th>\n",
       "      <td>32017070090</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>颜紫欣</th>\n",
       "      <td>32017070096</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>鹿方圆</th>\n",
       "      <td>32017070097</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>周冰雪</th>\n",
       "      <td>32017070139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>张博文</th>\n",
       "      <td>32017110044</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>叶芸杉</th>\n",
       "      <td>32017120048</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>李云天</th>\n",
       "      <td>32017120066</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>杜明旭</th>\n",
       "      <td>32017120070</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>马紫来</th>\n",
       "      <td>32017120095</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>高子轩</th>\n",
       "      <td>32017120096</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>郝雨桐</th>\n",
       "      <td>32017150053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>龙菁</th>\n",
       "      <td>32017150058</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Number\n",
       "Name             \n",
       "张泽远   22019207065\n",
       "王祎    22019208018\n",
       "李睿    22020210084\n",
       "韩文杰   22020210088\n",
       "崔明悦   22020210091\n",
       "吴英丽   22020210092\n",
       "刘昭含   22020210095\n",
       "张广芸   22020210096\n",
       "高玉莹   22020210097\n",
       "田光彬   22020210099\n",
       "桂启磊   22020210102\n",
       "高忠    22020210103\n",
       "张淑琪   22020210104\n",
       "刘聪    22020210105\n",
       "陈冰    22020210106\n",
       "肖瑶    22020210107\n",
       "彭佳    22020210109\n",
       "李梦雪   22020210110\n",
       "胡军    22020210111\n",
       "韩鑫    22020210112\n",
       "董欣雨   22020210113\n",
       "罗德鑫   22020030091\n",
       "张明明   22020039991\n",
       "李兴超   22020110133\n",
       "王海萍   22020120001\n",
       "石倩    22020120002\n",
       "杨婷    22020120003\n",
       "郁爱萍   22020120004\n",
       "刘姣    22020120006\n",
       "赵子树   22020120009\n",
       "王梓晗   22020120012\n",
       "孙可欣   22020120060\n",
       "郭慧鑫   22020120073\n",
       "张杜鹃   22020210007\n",
       "张旭    22020210008\n",
       "张峻杰   22020210009\n",
       "武梦笛   22020210010\n",
       "王丽然   22020210011\n",
       "张放    22020210012\n",
       "李沛璇   22020210013\n",
       "李健博   22020210014\n",
       "李夏猗   22020210015\n",
       "郭稼乐   22020210016\n",
       "宋昊    22020210017\n",
       "王琦    22020210018\n",
       "高蝶    22020210019\n",
       "刘羽    22020210020\n",
       "刘子卓   22020210021\n",
       "毛甫成   22020210022\n",
       "李岚婷   22020210023\n",
       "齐春晖   22020210024\n",
       "尹彭    22020210025\n",
       "赵佳    22020210026\n",
       "单腾飞   22020210027\n",
       "时少丹   22020210028\n",
       "韦敬宣   22020210029\n",
       "郭佳丽   22020210030\n",
       "张鸿伟   22020210031\n",
       "石如昆   22020210035\n",
       "白曼    22020210050\n",
       "王娇    22020210056\n",
       "许慧良   22020219991\n",
       "贾轩    22020210032\n",
       "王汝梦   22020210033\n",
       "张飞宇   22020210036\n",
       "蔡潇丹   22020210037\n",
       "张志宇   22020210038\n",
       "王宇轩   22020210039\n",
       "崔明月   22020210040\n",
       "李宗岳   22020210041\n",
       "陈立仲   22020210042\n",
       "何惠    22020210043\n",
       "张劭贤   22020210044\n",
       "李翔    22020210045\n",
       "余欣明   22020210046\n",
       "周春旭   22020210047\n",
       "万宏宇   22020210048\n",
       "刘双婷   22020210049\n",
       "谢磊鹏   22020210051\n",
       "刘中飞   22020210052\n",
       "封文森   22020210054\n",
       "张宇峰   22020210055\n",
       "于鸣霄   32017070001\n",
       "崔家欣   32017070008\n",
       "徐晓飞   32017070010\n",
       "曾宪春   32017070014\n",
       "杨雅婷   32017070022\n",
       "王玲月   32017070030\n",
       "秦昊堃   32017070033\n",
       "吴浩    32017070057\n",
       "张哲宇   32017070061\n",
       "张暄杰   32017070064\n",
       "王瀚    32017070079\n",
       "谭紫荷   32017070086\n",
       "邹远洋   32017070090\n",
       "颜紫欣   32017070096\n",
       "鹿方圆   32017070097\n",
       "周冰雪   32017070139\n",
       "张博文   32017110044\n",
       "叶芸杉   32017120048\n",
       "李云天   32017120066\n",
       "杜明旭   32017120070\n",
       "马紫来   32017120095\n",
       "高子轩   32017120096\n",
       "郝雨桐   32017150053\n",
       "龙菁    32017150058"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "ename": "KeyError",
     "evalue": "'name'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "\u001b[1;32mE:\\anaconda3\\lib\\site-packages\\pandas\\core\\indexes\\base.py\u001b[0m in \u001b[0;36mget_loc\u001b[1;34m(self, key, method, tolerance)\u001b[0m\n\u001b[0;32m   3062\u001b[0m             \u001b[1;32mtry\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 3063\u001b[1;33m                 \u001b[1;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   3064\u001b[0m             \u001b[1;32mexcept\u001b[0m \u001b[0mKeyError\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mpandas\\_libs\\index.pyx\u001b[0m in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;32mpandas\\_libs\\index.pyx\u001b[0m in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;32mpandas\\_libs\\hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;32mpandas\\_libs\\hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;31mKeyError\u001b[0m: 'name'",
      "\nDuring handling of the above exception, another exception occurred:\n",
      "\u001b[1;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-19-bf7507f319db>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mdata4\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mset_index\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m\"name\"\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0minplace\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;32mTrue\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;31m#将学会设置为索引\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m      2\u001b[0m \u001b[0mdata4\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mE:\\anaconda3\\lib\\site-packages\\pandas\\core\\frame.py\u001b[0m in \u001b[0;36mset_index\u001b[1;34m(self, keys, drop, append, inplace, verify_integrity)\u001b[0m\n\u001b[0;32m   3904\u001b[0m                 \u001b[0mnames\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;32mNone\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   3905\u001b[0m             \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 3906\u001b[1;33m                 \u001b[0mlevel\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mframe\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mcol\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_values\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   3907\u001b[0m                 \u001b[0mnames\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mcol\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   3908\u001b[0m                 \u001b[1;32mif\u001b[0m \u001b[0mdrop\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mE:\\anaconda3\\lib\\site-packages\\pandas\\core\\frame.py\u001b[0m in \u001b[0;36m__getitem__\u001b[1;34m(self, key)\u001b[0m\n\u001b[0;32m   2683\u001b[0m             \u001b[1;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_getitem_multilevel\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   2684\u001b[0m         \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 2685\u001b[1;33m             \u001b[1;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_getitem_column\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   2686\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   2687\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0m_getitem_column\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mkey\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mE:\\anaconda3\\lib\\site-packages\\pandas\\core\\frame.py\u001b[0m in \u001b[0;36m_getitem_column\u001b[1;34m(self, key)\u001b[0m\n\u001b[0;32m   2690\u001b[0m         \u001b[1;31m# get column\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   2691\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mis_unique\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 2692\u001b[1;33m             \u001b[1;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_get_item_cache\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   2693\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   2694\u001b[0m         \u001b[1;31m# duplicate columns & possible reduce dimensionality\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mE:\\anaconda3\\lib\\site-packages\\pandas\\core\\generic.py\u001b[0m in \u001b[0;36m_get_item_cache\u001b[1;34m(self, item)\u001b[0m\n\u001b[0;32m   2484\u001b[0m         \u001b[0mres\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mcache\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   2485\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mres\u001b[0m \u001b[1;32mis\u001b[0m \u001b[1;32mNone\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 2486\u001b[1;33m             \u001b[0mvalues\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_data\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   2487\u001b[0m             \u001b[0mres\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_box_item_values\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mvalues\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   2488\u001b[0m             \u001b[0mcache\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mitem\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mres\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mE:\\anaconda3\\lib\\site-packages\\pandas\\core\\internals.py\u001b[0m in \u001b[0;36mget\u001b[1;34m(self, item, fastpath)\u001b[0m\n\u001b[0;32m   4113\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   4114\u001b[0m             \u001b[1;32mif\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[0misna\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 4115\u001b[1;33m                 \u001b[0mloc\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mitems\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   4116\u001b[0m             \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   4117\u001b[0m                 \u001b[0mindexer\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mnp\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0marange\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mlen\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mitems\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0misna\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mitems\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mE:\\anaconda3\\lib\\site-packages\\pandas\\core\\indexes\\base.py\u001b[0m in \u001b[0;36mget_loc\u001b[1;34m(self, key, method, tolerance)\u001b[0m\n\u001b[0;32m   3063\u001b[0m                 \u001b[1;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   3064\u001b[0m             \u001b[1;32mexcept\u001b[0m \u001b[0mKeyError\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 3065\u001b[1;33m                 \u001b[1;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_maybe_cast_indexer\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   3066\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   3067\u001b[0m         \u001b[0mindexer\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget_indexer\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mkey\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmethod\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mmethod\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mtolerance\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mtolerance\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mpandas\\_libs\\index.pyx\u001b[0m in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;32mpandas\\_libs\\index.pyx\u001b[0m in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;32mpandas\\_libs\\hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;32mpandas\\_libs\\hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;31mKeyError\u001b[0m: 'name'"
     ]
    }
   ],
   "source": [
    "data4.set_index([\"name\"], inplace=True)#将学会设置为索引\n",
    "data4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
